package com.example.qxfw.ybzz.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.qxfw.common.entity.zy.SummaryProduct;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
@DS("service")
public interface SummaryProductMapper extends BaseMapper<SummaryProduct> {
    @Select("select id " +
            "from summary_product " +
            "where productname = ${strFileName} and producttype = ${strType} and producttype2 like '%${strType2}%' and year = ${strYear}")
    List<Integer> selectYearId(String strFileName,String strType,String strType2,String strYear);

    @Select("select id " +
            "from summary_product " +
            "where productname = ${strFileName} and producttype = ${strType}  and year = ${strYear}")
    List<Integer> selectId(String strFileName,String strType,String strYear);

}
